Northwind Test with Yukon

CustOrdersOrders Stored Procedure

Owner

dbo

Creation Date

10-07-2003 10:32:09

Remarks


Parameters

ParameterTypeSize
@CustomerIDnchar10

Source Code

CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)
AS
SELECT OrderID, 
	OrderDate,
	RequiredDate,
	ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderID